package com.game.majiang.vo;

import java.sql.Types;

import com.game.server.db.Parameter;
import com.game.server.db.ParameterType;
import com.game.server.db.SqlHelper;
import com.game.server.db.SqlHelperwrite;

public class CommodityPurchase_logVo {
	
	
	public static void insert(String CommodityName,int CommodityNumber,int CommodityTotalPrice,int PurchaseUserid){
		String cmdText = "INSERT INTO commodityPurchase_log (CommodityName,CommodityNumber,CommodityTotalPrice,PurchaseUserid) VALUES(?,?,?,?)";
		Parameter p1 = new Parameter(Types.VARCHAR,CommodityName,ParameterType.Input);
		Parameter p2 = new Parameter(Types.INTEGER, CommodityNumber,ParameterType.Input);
		Parameter p3 = new Parameter(Types.INTEGER, CommodityTotalPrice,ParameterType.Input);
		Parameter p4 = new Parameter(Types.INTEGER, PurchaseUserid,ParameterType.Input);
		
		SqlHelperwrite.execute(cmdText, p1,p2,p3,p4);
	}
	
}
